package com.sky.mapper.user;

import com.sky.pojo.User;
import com.sky.vo.CategorySelectIdVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface UserMapper {
    @Select("select * from user where openid=#{openId}")
    User selectByOpenId(String openId);

    int insertUser(User user);
    @Select("select * from category where status=1 ")
    List<CategorySelectIdVO> getByType();
    @Select("select * from user where id=#{id}")
    User getByUserId(Long id);
}
